﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Data;

   public class clsDADanhMuc
    {

       public DataTable GetDataTableSQL(string sql,string tbName) {
           DataTable tb = new DataTable(tbName);
           clsDAConnection conn = new clsDAConnection();
           conn.openCon();
           SqlDataAdapter apdapter = new SqlDataAdapter(sql,conn.getCon());
           apdapter.Fill(tb);
           conn.closeCon();
           return tb;
       }

      
       
    }

